package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.util.Scanner;

public class RegDemo {
    public static void main(String[] args) throws Exception {
        UserInfo userInfo= InputUtil.getInputObject(new UserInfo(),"注册吧你萨比","注册");
        System.out.println(userInfo);

        Class.forName("com.mysql.cj.jdbc.Driver");
        //与数据库连接
        Connection connection= DriverManager.getConnection(
                //格式：jdbc:mysql://主机地址信息/数据库名？参数列表
                "jdbc:mysql://localhost:3306/tedu?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true",
                "root","root");
        System.out.println("与数据库建立连接");
        Statement statement=connection.createStatement();//创建语句执行对象

//        Scanner sc=new Scanner(System.in);
//        System.out.println("请输入用户名：");
//        String username=sc.nextLine();
//        System.out.println("请输入密码：");
//        String password=sc.nextLine();
//        System.out.println("请输入昵称：");
//        String nickname=sc.nextLine();
//        System.out.println("请输入年龄：");
//        int age=Integer.parseInt(sc.nextLine());
//        String sql="INSERT INTO userinfo(username,password,nickname,age) " +
//                "VALUES ("+"'"+username+"'"+","+"'"+password+"'"+","+"'"+nickname+"'"+","+"'"+age+"'"+")";
        String sql="SELECT * FROM userinfo";
       // int nums=statement.executeUpdate(sql);
        statement.execute(sql);
//        if(nums>0)
//        {
//            System.out.println("注册成功");
//        }
        connection.close();
//
//        "INSERT INTO userinfo(username,password,nickname,age) " +
//                "VALUES ('zhangsan','123456','张三',18);";

    }
}
